#ifndef OPERACAODAO_H
#define OPERACAODAO_H

#include "dao.h"

#include "../entity/operacao.h"

CUSTOM_DAO(Operacao, "", DEFAULT_PAGE_SIZE, "id_depoperacao",
           Query("select dep_op.id_depoperacao, o.descricao, o.corapresentacao" \
                 " from prdepoperacao dep_op" \
                 " join properacao o on o.id_operacao = dep_op.id_operacao")
           .where("(dep_op.excluido = 0)")
           .orderBy("dep_op.postela, o.descricao"),
           DEFAULT_COUNT_QUERY)

#endif // OPERACAODAO_H
